-- SQL Manager 2005 Lite for SQL Server (2.7.0.2)
-- ---------------------------------------
-- Host      : (local)
-- Database  : DefectTrackingSystem
-- Version   : Microsoft SQL Server  9.00.4035.00


CREATE DATABASE [DefectTrackingSystem]
GO

USE [DefectTrackingSystem]
GO

--
-- Definition for table Role : 
--

CREATE TABLE [Role] (
  [RoleName] nvarchar(20) NOT NULL PRIMARY KEY
)
GO

--
-- Definition for table Group : 
--

CREATE TABLE [Group] (
  [GroupId] uniqueidentifier NOT NULL PRIMARY KEY,
  [GroupName] nvarchar(50) NOT NULL UNIQUE,
  [CreatedDate] datetime DEFAULT getdate() NOT NULL,
  [IsActived] bit NOT NULL
)
GO

--
-- Definition for table Account : 
--

CREATE TABLE [Account] (
  [AccountId] uniqueidentifier NOT NULL PRIMARY KEY,
  [UserName] nvarchar(50) NOT NULL UNIQUE,
  [Password] nvarchar(50) NOT NULL,
  [Role] nvarchar(20) NULL FOREIGN KEY REFERENCES [Role] ([RoleName]),
  [CreatedDate] datetime DEFAULT getdate() NOT NULL,
  [GroupId] uniqueidentifier NOT NULL FOREIGN KEY REFERENCES [Group] ([GroupId]),
  [IsActive] bit NOT NULL
)
GO

--
-- Definition for table Profile : 
--

CREATE TABLE [Profile] (
  [ProfileId] uniqueidentifier NOT NULL PRIMARY KEY,
  [AccountId] uniqueidentifier NOT NULL UNIQUE FOREIGN KEY REFERENCES [Account] ([AccountId]),
  [FirstName] nvarchar(30) NOT NULL,
  [LastName] nvarchar(30) NOT NULL,
  [Address] nvarchar(255) NULL,
  [Email] varchar(255) NOT NULL UNIQUE
)
GO

--
-- Definition for table Project : 
--

CREATE TABLE [Project] (
  [ProjectId] uniqueidentifier NOT NULL PRIMARY KEY,
  [ProjectName] nvarchar(50) NOT NULL, -- UNIQUE WITHIN A GROUP, WRITE TRIGER TO CHECK
  [Description] nvarchar(4000) NULL,
  [CreatedDate] datetime DEFAULT getdate() NOT NULL,
  [Creator] uniqueidentifier NOT NULL FOREIGN KEY REFERENCES [Account] ([AccountId]),
  [IsActive] bit NOT NULL
)
GO

--
-- Definition for table Client : 
--

CREATE TABLE [Client] (
  [ClientId] uniqueidentifier NOT NULL PRIMARY KEY,
  [GroupId] uniqueidentifier NOT NULL FOREIGN KEY REFERENCES [Group] ([GroupId]),
  [FirstName] nvarchar(30) NOT NULL,
  [LastName] nvarchar(30) NOT NULL,
  [Company] nvarchar(50) NOT NULL,
  [Email] varchar(50) NOT NULL UNIQUE,
  [CreatedDate] datetime DEFAULT getdate() NOT NULL
)
GO

--
-- Definition for table Defect : 
--

CREATE TABLE [Defect] (
  [DefectId] uniqueidentifier NOT NULL PRIMARY KEY,
  [ProjectId] uniqueidentifier NOT NULL FOREIGN KEY REFERENCES [Project] ([ProjectId]),
  [DefectTitle] nvarchar(50) NOT NULL,
  [DefectNumber] int NOT NULL,--UNIQUE WITH PROJECT, NEED TRIGER TO CHECK
  [CreatedDate] datetime DEFAULT getdate() NOT NULL,
  [Description] nvarchar(4000) NOT NULL,
  [Diagnosis] nvarchar(4000) NULL,
  [AssignedMember] uniqueidentifier NULL FOREIGN KEY REFERENCES [Account] ([AccountId]),
  [Creator] uniqueidentifier NOT NULL FOREIGN KEY REFERENCES [Account] ([AccountId]),
  [Originator] uniqueidentifier NOT NULL FOREIGN KEY REFERENCES [Client] ([ClientId]) ,
  [Type] nvarchar(50) NOT NULL,
  [Version] nvarchar(50) NOT NULL,
  [Priority] nvarchar(50) NOT NULL,
  [Status] nvarchar(50) NOT NULL,
  [IsClosed] bit NOT NULL
)
GO

--
-- Definition for table Attachment : 
--

CREATE TABLE [Attachment] (
  [AttachId] uniqueidentifier NOT NULL PRIMARY KEY,
  [DefectId] uniqueidentifier NOT NULL FOREIGN KEY REFERENCES [Defect] ([DefectId]),
  [FileName] nvarchar(100) NOT NULL,
  [Path] nvarchar(200) NOT NULL,
  [AttachDate] datetime DEFAULT getdate() NOT NULL,
  [Size] int NOT NULL,
  [Uploader] uniqueidentifier NOT NULL FOREIGN KEY REFERENCES [Account] ([AccountId])
)
GO

--
-- Definition for table Comment : 
--

CREATE TABLE [Comment] (
  [CommentId] uniqueidentifier NOT NULL PRIMARY KEY,
  [DefectId] uniqueidentifier NOT NULL FOREIGN KEY REFERENCES [Defect] ([DefectId]),
  [Comment] nvarchar(4000) NOT NULL,
  [Creator] uniqueidentifier NOT NULL FOREIGN KEY REFERENCES [Account] ([AccountId]),
  [CreatedDate] datetime DEFAULT getdate() NOT NULL
)
GO

--
-- Definition for table DefectResolution : 
--

CREATE TABLE [DefectResolution] (
  [ResolutionId] uniqueidentifier NOT NULL PRIMARY KEY,
  [DefectId] uniqueidentifier NOT NULL UNIQUE FOREIGN KEY REFERENCES [Defect] ([DefectId]),
  [Solution] nvarchar(max) NOT NULL,
  [FixTime] int NOT NULL,
  [TestedBy] uniqueidentifier NULL FOREIGN KEY REFERENCES [Account] ([AccountId])
)
GO

--
-- Definition for table DefectLog : 
--

CREATE TABLE [DefectLog] (
  [LogId] uniqueidentifier NOT NULL PRIMARY KEY,
  [Content] nvarchar(200) NOT NULL,
  [User] uniqueidentifier NOT NULL FOREIGN KEY REFERENCES [Account] ([AccountId]),
  [CreatedTime] datetime DEFAULT getdate() NOT NULL,
  [DefectId] uniqueidentifier NOT NULL FOREIGN KEY REFERENCES [Defect] ([DefectId])
)
GO

--
-- Definition for table DefectPriority : 
--

CREATE TABLE [DefectPriority] (
  [Priority] nvarchar(50) NOT NULL,
  [ProjectId] uniqueidentifier NOT NULL FOREIGN KEY REFERENCES [Project] ([ProjectId]),
  PRIMARY KEY ([Priority], [ProjectId])
)
GO

--
-- Definition for table DefectStatus : 
--

CREATE TABLE [DefectStatus] (
  [Status] nvarchar(50) NOT NULL,
  [ProjectId] uniqueidentifier NOT NULL FOREIGN KEY REFERENCES [Project] ([ProjectId]),
  PRIMARY KEY ([Status], [ProjectId])
)
GO

--
-- Definition for table DefectType : 
--

CREATE TABLE [DefectType] (
  [TypeName] nvarchar(50) NOT NULL,
  [ProjectId] uniqueidentifier NOT NULL FOREIGN KEY REFERENCES [Project] ([ProjectId]),
  PRIMARY KEY ([TypeName], [ProjectId])
)
GO

--
-- Definition for table EmailNotificationCase : 
--

CREATE TABLE [EmailNotificationCase] (
  [CaseID] nvarchar(50) NOT NULL PRIMARY KEY,
  [CaseName] nvarchar(100) NOT NULL,
  [Type] nvarchar(50)NOT NULL
)
GO

--
-- Definition for table EmailNotificationSettings : 
--

CREATE TABLE [EmailNotificationSettings] (
  [AccountId] uniqueidentifier NOT NULL FOREIGN KEY REFERENCES [Account] ([AccountId]),
  [CaseId] nvarchar(50) NOT NULL FOREIGN KEY REFERENCES [EmailNotificationCase] ([CaseID]),
  Temp bit NULL,
  PRIMARY KEY ([AccountId], [CaseId])
)
GO

--
-- Definition for table ProjectMembers : 
--

CREATE TABLE [ProjectMembers] (
  [AccountId] uniqueidentifier NOT NULL FOREIGN KEY REFERENCES [Account] ([AccountId]),
  [ProjectId] uniqueidentifier NOT NULL FOREIGN KEY REFERENCES [Project] ([ProjectId]),
  [IsAssigned] bit NOT NULL,
  PRIMARY KEY ([AccountId], [ProjectId])
)
GO

--
-- Definition for table ProjectVersion : 
--

CREATE TABLE [ProjectVersion] (
  [VersionName] nvarchar(50) NOT NULL,
  [ProjectId] uniqueidentifier NOT NULL FOREIGN KEY REFERENCES [Project] ([ProjectId]),
  PRIMARY KEY ([VersionName], [ProjectId])
)
GO
--
-- Data for table Role  (LIMIT 0,500)
--
INSERT INTO [dbo].[Role] ([RoleName])
VALUES 
  ('Group Admin')
GO

INSERT INTO [dbo].[Role] ([RoleName])
VALUES 
  ('Project Admin')
GO

INSERT INTO [dbo].[Role] ([RoleName])
VALUES 
  ('System Admin')
GO

INSERT INTO [dbo].[Role] ([RoleName])
VALUES 
  ('User')
GO
--
-- Data for table EmailNotificationCase  (LIMIT 0,500)
--

INSERT INTO [dbo].[EmailNotificationCase] ([CaseID], [CaseName], [Type])
VALUES 
  ('DefectAssignedToMe', 'Assigned To Me', 'NewDefect')
GO

INSERT INTO [dbo].[EmailNotificationCase] ([CaseID], [CaseName], [Type])
VALUES 
  ('DefectAssignedToMeClosed', 'Closed', 'DefectAssignedToMe')
GO

INSERT INTO [dbo].[EmailNotificationCase] ([CaseID], [CaseName], [Type])
VALUES 
  ('DefectAssignedToMeNewComment', 'Have new comments', 'DefectAssignedToMe')
GO

INSERT INTO [dbo].[EmailNotificationCase] ([CaseID], [CaseName], [Type])
VALUES 
  ('DefectAssignedToMePriorityChange', 'Priority Change', 'DefectAssignedToMe')
GO

INSERT INTO [dbo].[EmailNotificationCase] ([CaseID], [CaseName], [Type])
VALUES 
  ('DefectAssignedToMeReOpened', 'Re-opened', 'DefectAssignedToMe')
GO

INSERT INTO [dbo].[EmailNotificationCase] ([CaseID], [CaseName], [Type])
VALUES 
  ('DefectAssignedToMeStatusChange', 'Status Change', 'DefectAssignedToMe')
GO

INSERT INTO [dbo].[EmailNotificationCase] ([CaseID], [CaseName], [Type])
VALUES 
  ('DefectCreatedByMe', 'Created By Me', 'NewDefect')
GO

INSERT INTO [dbo].[EmailNotificationCase] ([CaseID], [CaseName], [Type])
VALUES 
  ('DefectCreatedByMeClosed', 'Closed', 'DefectCreatedByMe')
GO

INSERT INTO [dbo].[EmailNotificationCase] ([CaseID], [CaseName], [Type])
VALUES 
  ('DefectCreatedByMeNewComment', 'Have new comments', 'DefectCreatedByMe')
GO

INSERT INTO [dbo].[EmailNotificationCase] ([CaseID], [CaseName], [Type])
VALUES 
  ('DefectCreatedByMePriorityChange', 'Priority Change', 'DefectCreatedByMe')
GO

INSERT INTO [dbo].[EmailNotificationCase] ([CaseID], [CaseName], [Type])
VALUES 
  ('DefectCreatedByMeReOpened', 'Re-opened', 'DefectCreatedByMe')
GO

INSERT INTO [dbo].[EmailNotificationCase] ([CaseID], [CaseName], [Type])
VALUES 
  ('DefectCreatedByMeStatusChange', 'Status Change', 'DefectCreatedByMe')
GO

INSERT INTO [dbo].[EmailNotificationCase] ([CaseID], [CaseName], [Type])
VALUES 
  ('DefectReassignedToSomeOneElse', 'Reassigned to someone else', 'NewDefect')
GO

INSERT INTO [dbo].[Group] ([GroupId], [GroupName], [CreatedDate], [IsActived])
VALUES 
  ('{B4EA0E27-1DA5-43FB-B3CB-B2195E8B3EBF}', 'System', '20110709 13:27:29.423', 1)
GO

INSERT INTO [dbo].[Account] ([AccountId], [UserName], [Password], [Role], [CreatedDate], [GroupId], [IsActive])
VALUES 
  ('{D5660EE9-99A3-4C2C-84D1-EF38F6FA2D15}', 'admin', 'e10adc3949ba59abbe56e057f20f883e', 'System Admin', '20110709 13:30:09.010', '{B4EA0E27-1DA5-43FB-B3CB-B2195E8B3EBF}', 1)
GO

INSERT INTO [dbo].[Group] ([GroupId], [GroupName], [CreatedDate], [IsActived])
VALUES 
  ('{44DD6A63-F753-450A-B104-FD2FF6572C74}', 'Bamboo', '20110709 14:15:15.163', 1)
GO

--
-- 2 record(s) inserted to [dbo].[Group]
--



--
-- Data for table Account  (LIMIT 0,500)
--

INSERT INTO [dbo].[Account] ([AccountId], [UserName], [Password], [Role], [CreatedDate], [GroupId], [IsActive])
VALUES 
  ('{B700F39E-BAEB-4FB6-AA13-366E158EF43A}', 'robo8590', 'e10adc3949ba59abbe56e057f20f883e', 'User', '20110709 14:16:05.073', '{44DD6A63-F753-450A-B104-FD2FF6572C74}', 1)
GO

INSERT INTO [dbo].[Account] ([AccountId], [UserName], [Password], [Role], [CreatedDate], [GroupId], [IsActive])
VALUES 
  ('{91FAE1EC-4BA6-4EF2-B97F-4E4F47B7FC28}', 'tobynguyen', 'e10adc3949ba59abbe56e057f20f883e', 'User', '20110709 14:26:24.950', '{44DD6A63-F753-450A-B104-FD2FF6572C74}', 1)
GO

INSERT INTO [dbo].[Account] ([AccountId], [UserName], [Password], [Role], [CreatedDate], [GroupId], [IsActive])
VALUES 
  ('{32235B19-DB94-486C-8BC8-6A194985527F}', 'chung1991', 'e10adc3949ba59abbe56e057f20f883e', 'Project Admin', '20110709 14:20:32.827', '{44DD6A63-F753-450A-B104-FD2FF6572C74}', 1)
GO

INSERT INTO [dbo].[Account] ([AccountId], [UserName], [Password], [Role], [CreatedDate], [GroupId], [IsActive])
VALUES 
  ('{24BCBED1-C724-45CE-9F75-6FCACE0FA18E}', 'tony8590', 'e10adc3949ba59abbe56e057f20f883e', 'User', '20110709 14:23:28.743', '{44DD6A63-F753-450A-B104-FD2FF6572C74}', 1)
GO

INSERT INTO [dbo].[Account] ([AccountId], [UserName], [Password], [Role], [CreatedDate], [GroupId], [IsActive])
VALUES 
  ('{91D0B3EC-FAB6-4B3E-A2F8-81AB0178B3E1}', 'ndc91091', 'e10adc3949ba59abbe56e057f20f883e', 'Project Admin', '20110709 14:16:55.130', '{44DD6A63-F753-450A-B104-FD2FF6572C74}', 1)
GO

INSERT INTO [dbo].[Account] ([AccountId], [UserName], [Password], [Role], [CreatedDate], [GroupId], [IsActive])
VALUES 
  ('{68CF8395-7408-4B82-80DD-9D26592C426B}', 'joinnguyen', 'e10adc3949ba59abbe56e057f20f883e', 'User', '20110709 14:22:34.720', '{44DD6A63-F753-450A-B104-FD2FF6572C74}', 1)
GO

INSERT INTO [dbo].[Account] ([AccountId], [UserName], [Password], [Role], [CreatedDate], [GroupId], [IsActive])
VALUES 
  ('{3E44B415-597D-4F9F-A350-A31D8260271E}', 'lilytran', 'e10adc3949ba59abbe56e057f20f883e', 'User', '20110709 14:24:00.743', '{44DD6A63-F753-450A-B104-FD2FF6572C74}', 1)
GO

INSERT INTO [dbo].[Account] ([AccountId], [UserName], [Password], [Role], [CreatedDate], [GroupId], [IsActive])
VALUES 
  ('{5FF59522-7A76-48E5-AD74-ACF4B6ECCF34}', 'lindatran', 'e10adc3949ba59abbe56e057f20f883e', 'User', '20110709 14:25:54.750', '{44DD6A63-F753-450A-B104-FD2FF6572C74}', 1)
GO

INSERT INTO [dbo].[Account] ([AccountId], [UserName], [Password], [Role], [CreatedDate], [GroupId], [IsActive])
VALUES 
  ('{60C3360F-76AF-4036-833C-BCBC64E5B1C2}', 'nam8590', 'e10adc3949ba59abbe56e057f20f883e', 'Group Admin', '20110709 14:15:15.180', '{44DD6A63-F753-450A-B104-FD2FF6572C74}', 1)
GO

INSERT INTO [dbo].[Account] ([AccountId], [UserName], [Password], [Role], [CreatedDate], [GroupId], [IsActive])
VALUES 
  ('{A3338CFA-E392-43E8-99F2-C64E283EF37D}', 'dungdoan', 'e10adc3949ba59abbe56e057f20f883e', 'Project Admin', '20110709 14:20:57.417', '{44DD6A63-F753-450A-B104-FD2FF6572C74}', 1)
GO

INSERT INTO [dbo].[Account] ([AccountId], [UserName], [Password], [Role], [CreatedDate], [GroupId], [IsActive])
VALUES 
  ('{925872DB-E99B-4639-8B15-F32A2545AB5F}', 'nguyen1990', 'e10adc3949ba59abbe56e057f20f883e', 'User', '20110709 14:21:29.110', '{44DD6A63-F753-450A-B104-FD2FF6572C74}', 1)
GO

--
-- 12 record(s) inserted to [dbo].[Account]
--



--
-- Data for table Project  (LIMIT 0,500)
--

INSERT INTO [dbo].[Project] ([ProjectId], [ProjectName], [Description], [CreatedDate], [Creator], [IsActive])
VALUES 
  ('{04E7DA3D-D0E2-4176-91C4-01F1AFCA6115}', 'Library Website', 'Library Website', '20110709 14:40:28.140', '{60C3360F-76AF-4036-833C-BCBC64E5B1C2}', 1)
GO

INSERT INTO [dbo].[Project] ([ProjectId], [ProjectName], [Description], [CreatedDate], [Creator], [IsActive])
VALUES 
  ('{2B582B89-576B-45F7-92B6-23E3361CC996}', 'Social Website', 'Social Website', '20110709 14:35:20.687', '{60C3360F-76AF-4036-833C-BCBC64E5B1C2}', 1)
GO

INSERT INTO [dbo].[Project] ([ProjectId], [ProjectName], [Description], [CreatedDate], [Creator], [IsActive])
VALUES 
  ('{522618B9-225F-4752-8EE4-38E044B4CBB1}', 'Wethers News Website', 'Wethers News Website', '20110709 14:35:51.013', '{60C3360F-76AF-4036-833C-BCBC64E5B1C2}', 1)
GO

INSERT INTO [dbo].[Project] ([ProjectId], [ProjectName], [Description], [CreatedDate], [Creator], [IsActive])
VALUES 
  ('{797EC3E0-1895-4497-8337-39E274EA35AC}', 'Defect Tracking System', 'Bug tracking, Defect Tracking, Issue Tracking', '20110709 14:31:29.853', '{60C3360F-76AF-4036-833C-BCBC64E5B1C2}', 1)
GO

INSERT INTO [dbo].[Project] ([ProjectId], [ProjectName], [Description], [CreatedDate], [Creator], [IsActive])
VALUES 
  ('{E4948F3F-22D6-4B44-8EF0-5E428A1C4861}', 'FootBall News Website', 'FootBall News Website', '20110709 14:40:00.630', '{60C3360F-76AF-4036-833C-BCBC64E5B1C2}', 1)
GO

INSERT INTO [dbo].[Project] ([ProjectId], [ProjectName], [Description], [CreatedDate], [Creator], [IsActive])
VALUES 
  ('{8EEEAB6F-CD0F-463C-9925-658787CD6D52}', 'FPT-Aptech', 'FPT-Aptech', '20110709 14:36:17.840', '{60C3360F-76AF-4036-833C-BCBC64E5B1C2}', 1)
GO

INSERT INTO [dbo].[Project] ([ProjectId], [ProjectName], [Description], [CreatedDate], [Creator], [IsActive])
VALUES 
  ('{CF1B718F-E313-45CE-842A-6E1E6257A2A9}', 'Shopping Cart Online', 'Shopping Online', '20110709 14:32:19.760', '{60C3360F-76AF-4036-833C-BCBC64E5B1C2}', 1)
GO

INSERT INTO [dbo].[Project] ([ProjectId], [ProjectName], [Description], [CreatedDate], [Creator], [IsActive])
VALUES 
  ('{1F61EE21-AC7D-411A-9F40-7101E87742FF}', 'Bank Website', 'Bank Website', '20110709 14:39:46.177', '{60C3360F-76AF-4036-833C-BCBC64E5B1C2}', 1)
GO

INSERT INTO [dbo].[Project] ([ProjectId], [ProjectName], [Description], [CreatedDate], [Creator], [IsActive])
VALUES 
  ('{3CE2CD44-EB6E-451D-9A27-72A1EC039DEA}', 'Flower Shop', 'Flower Shop', '20110709 14:36:51.180', '{60C3360F-76AF-4036-833C-BCBC64E5B1C2}', 1)
GO

INSERT INTO [dbo].[Project] ([ProjectId], [ProjectName], [Description], [CreatedDate], [Creator], [IsActive])
VALUES 
  ('{7195229E-6D02-4D5D-BD88-C72EF3418412}', 'Book Website', 'Book Website', '20110709 14:40:16.147', '{60C3360F-76AF-4036-833C-BCBC64E5B1C2}', 1)
GO

INSERT INTO [dbo].[Project] ([ProjectId], [ProjectName], [Description], [CreatedDate], [Creator], [IsActive])
VALUES 
  ('{D1ACE968-5222-4C65-B915-D45C4243FE2C}', 'Excell Online Website', 'Excell Online Website', '20110709 14:36:03.257', '{60C3360F-76AF-4036-833C-BCBC64E5B1C2}', 1)
GO

INSERT INTO [dbo].[Project] ([ProjectId], [ProjectName], [Description], [CreatedDate], [Creator], [IsActive])
VALUES 
  ('{278B8E41-25D1-4F21-B96B-FEE5887232CA}', 'News Website', 'News Website', '20110709 14:35:39.660', '{60C3360F-76AF-4036-833C-BCBC64E5B1C2}', 1)
GO

--
-- 12 record(s) inserted to [dbo].[Project]
--



--
-- Data for table Client  (LIMIT 0,500)
--

INSERT INTO [dbo].[Client] ([ClientId], [GroupId], [FirstName], [LastName], [Company], [Email], [CreatedDate])
VALUES 
  ('{3518090B-549F-4033-A467-183495D816F3}', '{44DD6A63-F753-450A-B104-FD2FF6572C74}', 'Canh', 'Nguyen', 'FPT-Aptech', 'ndc91091@fpt-aptech.com', '20110709 14:28:57.260')
GO

INSERT INTO [dbo].[Client] ([ClientId], [GroupId], [FirstName], [LastName], [Company], [Email], [CreatedDate])
VALUES 
  ('{DC67DCD0-C608-481E-B381-37D8C9CB6E72}', '{44DD6A63-F753-450A-B104-FD2FF6572C74}', 'Nam', 'Tran', 'FPT-Aptech', 'namtran@fpt-aptech.com', '20110709 14:28:29.727')
GO

INSERT INTO [dbo].[Client] ([ClientId], [GroupId], [FirstName], [LastName], [Company], [Email], [CreatedDate])
VALUES 
  ('{6BA157C2-6C30-4FFF-B306-3AA204F1288D}', '{44DD6A63-F753-450A-B104-FD2FF6572C74}', 'Dung', 'Doan', 'Yahoo', 'dungdoan@yahoo.com', '20110709 14:29:59.480')
GO

INSERT INTO [dbo].[Client] ([ClientId], [GroupId], [FirstName], [LastName], [Company], [Email], [CreatedDate])
VALUES 
  ('{90E7F9B3-53E4-4A5C-92B9-438F32089BCC}', '{44DD6A63-F753-450A-B104-FD2FF6572C74}', 'Chung', 'Nguyen', 'FPT', 'chungnguyen@fpt.com', '20110709 14:28:02.937')
GO

INSERT INTO [dbo].[Client] ([ClientId], [GroupId], [FirstName], [LastName], [Company], [Email], [CreatedDate])
VALUES 
  ('{5672E0F5-7643-4EF7-B7DA-4FEDCCD3796C}', '{44DD6A63-F753-450A-B104-FD2FF6572C74}', 'Dung', 'Doan', 'FPT', 'dungdoan@fpt.com', '20110709 14:27:50.630')
GO

INSERT INTO [dbo].[Client] ([ClientId], [GroupId], [FirstName], [LastName], [Company], [Email], [CreatedDate])
VALUES 
  ('{F35901DC-86E6-47C7-8B0F-5B1A8F7B90C1}', '{44DD6A63-F753-450A-B104-FD2FF6572C74}', 'Nam', 'Tran', 'Microsoft', 'namtran@microsoft.com', '20110709 14:27:18.460')
GO

INSERT INTO [dbo].[Client] ([ClientId], [GroupId], [FirstName], [LastName], [Company], [Email], [CreatedDate])
VALUES 
  ('{13743736-2273-45A9-B574-618C8D49FEAE}', '{44DD6A63-F753-450A-B104-FD2FF6572C74}', 'Dung', 'Doan', 'FPT-Aptech', 'dungdoan@fpt-aptech.com', '20110709 14:28:46.803')
GO

INSERT INTO [dbo].[Client] ([ClientId], [GroupId], [FirstName], [LastName], [Company], [Email], [CreatedDate])
VALUES 
  ('{EDB87535-17DC-4C00-AFD5-9A940DD76D6C}', '{44DD6A63-F753-450A-B104-FD2FF6572C74}', 'Canh', 'Nguyen', 'FPT', 'ndc91091@fpt.com', '20110709 14:27:37.727')
GO

INSERT INTO [dbo].[Client] ([ClientId], [GroupId], [FirstName], [LastName], [Company], [Email], [CreatedDate])
VALUES 
  ('{CB706F49-A6AD-42DE-88CC-B67E548648C4}', '{44DD6A63-F753-450A-B104-FD2FF6572C74}', 'Chung', 'Nguyen', 'Yahoo', 'chungnguyen@yahoo.com', '20110709 14:29:25.567')
GO

INSERT INTO [dbo].[Client] ([ClientId], [GroupId], [FirstName], [LastName], [Company], [Email], [CreatedDate])
VALUES 
  ('{2DCE44BD-B8A7-45E2-A3B4-C483D2F44289}', '{44DD6A63-F753-450A-B104-FD2FF6572C74}', 'Nam', 'Tran', 'Yahoo', 'namtran@yahoo.com', '20110709 14:29:44.380')
GO

INSERT INTO [dbo].[Client] ([ClientId], [GroupId], [FirstName], [LastName], [Company], [Email], [CreatedDate])
VALUES 
  ('{CC7B7478-1A7B-4B11-AF03-E8E663D61578}', '{44DD6A63-F753-450A-B104-FD2FF6572C74}', 'Canh', 'Nguyen', 'Yahoo', 'ndc91091@yahoo.com', '20110709 14:29:36.037')
GO

INSERT INTO [dbo].[Client] ([ClientId], [GroupId], [FirstName], [LastName], [Company], [Email], [CreatedDate])
VALUES 
  ('{728712B4-D243-4937-9B30-F1728647D718}', '{44DD6A63-F753-450A-B104-FD2FF6572C74}', 'Chung', 'Nguyen', 'FPT-Aptech', 'chungnguyen@fpt-aptech.com', '20110709 14:28:16.343')
GO

INSERT INTO [dbo].[Client] ([ClientId], [GroupId], [FirstName], [LastName], [Company], [Email], [CreatedDate])
VALUES 
  ('{B2878D65-57ED-489F-BC16-F244930A6D99}', '{44DD6A63-F753-450A-B104-FD2FF6572C74}', 'Nam', 'Tran', 'FPT', 'namtran@fpt.com', '20110709 14:27:28.813')
GO

--
-- 13 record(s) inserted to [dbo].[Client]
--



--
-- Data for table Defect  (LIMIT 0,500)
--

INSERT INTO [dbo].[Defect] ([DefectId], [ProjectId], [DefectTitle], [DefectNumber], [CreatedDate], [Description], [Diagnosis], [AssignedMember], [Creator], [Originator], [Type], [Version], [Priority], [Status], [IsClosed])
VALUES 
  ('{8CFBFDFC-62BF-4F2E-ACB0-3E7C72CC5A22}', '{1F61EE21-AC7D-411A-9F40-7101E87742FF}', 'Bug 22', 9, '20110709 15:14:17.920', '<p>@@ Error every thing. Javascript not run</p>', 'I don''t know', '{68CF8395-7408-4B82-80DD-9D26592C426B}', '{60C3360F-76AF-4036-833C-BCBC64E5B1C2}', '{3518090B-549F-4033-A467-183495D816F3}', 'Bug', '1.2', 'High', 'In Process', 0)
GO

INSERT INTO [dbo].[Defect] ([DefectId], [ProjectId], [DefectTitle], [DefectNumber], [CreatedDate], [Description], [Diagnosis], [AssignedMember], [Creator], [Originator], [Type], [Version], [Priority], [Status], [IsClosed])
VALUES 
  ('{EC26AE17-AB4D-4E6E-8896-4D91C42DC964}', '{797EC3E0-1895-4497-8337-39E274EA35AC}', 'Bug 5', 5, '20110709 15:12:19.237', '<p>Improvement</p>', NULL, '{A3338CFA-E392-43E8-99F2-C64E283EF37D}', '{60C3360F-76AF-4036-833C-BCBC64E5B1C2}', '{3518090B-549F-4033-A467-183495D816F3}', 'Improvement', '1.0', 'Low', 'In Process', 0)
GO

INSERT INTO [dbo].[Defect] ([DefectId], [ProjectId], [DefectTitle], [DefectNumber], [CreatedDate], [Description], [Diagnosis], [AssignedMember], [Creator], [Originator], [Type], [Version], [Priority], [Status], [IsClosed])
VALUES 
  ('{A82D74E6-451C-4DFA-A890-60F23EC91E0F}', '{797EC3E0-1895-4497-8337-39E274EA35AC}', 'Bug 3', 3, '20110709 14:51:38.223', '<p>I can view all projects</p>', 'I don''t know', '{32235B19-DB94-486C-8BC8-6A194985527F}', '{60C3360F-76AF-4036-833C-BCBC64E5B1C2}', '{3518090B-549F-4033-A467-183495D816F3}', 'Bug', '1.2', 'High', 'Not Started', 0)
GO

INSERT INTO [dbo].[Defect] ([DefectId], [ProjectId], [DefectTitle], [DefectNumber], [CreatedDate], [Description], [Diagnosis], [AssignedMember], [Creator], [Originator], [Type], [Version], [Priority], [Status], [IsClosed])
VALUES 
  ('{7B335EDB-EE45-4253-80B0-684C32CE43EE}', '{1F61EE21-AC7D-411A-9F40-7101E87742FF}', 'Bug 1', 5, '20110709 15:01:32.893', '<p>I don''t register a&nbsp;account</p>', NULL, '{68CF8395-7408-4B82-80DD-9D26592C426B}', '{60C3360F-76AF-4036-833C-BCBC64E5B1C2}', '{3518090B-549F-4033-A467-183495D816F3}', 'Bug', '1.0', 'High', 'In Process', 0)
GO

INSERT INTO [dbo].[Defect] ([DefectId], [ProjectId], [DefectTitle], [DefectNumber], [CreatedDate], [Description], [Diagnosis], [AssignedMember], [Creator], [Originator], [Type], [Version], [Priority], [Status], [IsClosed])
VALUES 
  ('{E5EE9468-4700-44A6-8C15-7C11DB245BE7}', '{1F61EE21-AC7D-411A-9F40-7101E87742FF}', 'Bug 23', 10, '20110709 15:14:44.653', '<p>@@ Error every thing. Ajax didn''t run</p>', 'I don''t know', '{68CF8395-7408-4B82-80DD-9D26592C426B}', '{60C3360F-76AF-4036-833C-BCBC64E5B1C2}', '{3518090B-549F-4033-A467-183495D816F3}', 'Document', '1.2', 'Medium', 'In Process', 0)
GO

INSERT INTO [dbo].[Defect] ([DefectId], [ProjectId], [DefectTitle], [DefectNumber], [CreatedDate], [Description], [Diagnosis], [AssignedMember], [Creator], [Originator], [Type], [Version], [Priority], [Status], [IsClosed])
VALUES 
  ('{107FD9CE-CDD1-4F48-A35A-7CFC97F72FDF}', '{797EC3E0-1895-4497-8337-39E274EA35AC}', 'Bug 4', 4, '20110709 14:59:27.430', '<p>I can''t Report resolution</p>', 'I don''t know', '{A3338CFA-E392-43E8-99F2-C64E283EF37D}', '{60C3360F-76AF-4036-833C-BCBC64E5B1C2}', '{3518090B-549F-4033-A467-183495D816F3}', 'Bug', '1.1', 'High', 'Completed', 0)
GO

INSERT INTO [dbo].[Defect] ([DefectId], [ProjectId], [DefectTitle], [DefectNumber], [CreatedDate], [Description], [Diagnosis], [AssignedMember], [Creator], [Originator], [Type], [Version], [Priority], [Status], [IsClosed])
VALUES 
  ('{98ACCF5B-C3B1-447B-93FC-7F12E137F741}', '{1F61EE21-AC7D-411A-9F40-7101E87742FF}', 'Bug 2', 6, '20110709 15:07:11.623', '<p>I can''t change my information</p>', NULL, '{3E44B415-597D-4F9F-A350-A31D8260271E}', '{60C3360F-76AF-4036-833C-BCBC64E5B1C2}', '{3518090B-549F-4033-A467-183495D816F3}', 'Bug', '1.1', 'High', 'In Process', 0)
GO

INSERT INTO [dbo].[Defect] ([DefectId], [ProjectId], [DefectTitle], [DefectNumber], [CreatedDate], [Description], [Diagnosis], [AssignedMember], [Creator], [Originator], [Type], [Version], [Priority], [Status], [IsClosed])
VALUES 
  ('{72E1A74F-B8E2-48FF-955B-A59D62DE61E5}', '{1F61EE21-AC7D-411A-9F40-7101E87742FF}', 'Bug 3', 7, '20110709 15:07:29.787', '<p>I can''t change my email</p>', NULL, '{3E44B415-597D-4F9F-A350-A31D8260271E}', '{60C3360F-76AF-4036-833C-BCBC64E5B1C2}', '{3518090B-549F-4033-A467-183495D816F3}', 'Bug', '1.1', 'High', 'Complete', 0)
GO

INSERT INTO [dbo].[Defect] ([DefectId], [ProjectId], [DefectTitle], [DefectNumber], [CreatedDate], [Description], [Diagnosis], [AssignedMember], [Creator], [Originator], [Type], [Version], [Priority], [Status], [IsClosed])
VALUES 
  ('{9548A0D1-4F38-44CD-9743-A6107A18E6FD}', '{797EC3E0-1895-4497-8337-39E274EA35AC}', 'Bug 1', 1, '20110709 14:50:33.810', '<p>I can''t login in to system</p>', 'I don''t know', '{32235B19-DB94-486C-8BC8-6A194985527F}', '{60C3360F-76AF-4036-833C-BCBC64E5B1C2}', '{3518090B-549F-4033-A467-183495D816F3}', 'Bug', '1.0', 'High', 'Not Started', 0)
GO

INSERT INTO [dbo].[Defect] ([DefectId], [ProjectId], [DefectTitle], [DefectNumber], [CreatedDate], [Description], [Diagnosis], [AssignedMember], [Creator], [Originator], [Type], [Version], [Priority], [Status], [IsClosed])
VALUES 
  ('{8DAC0B34-BD6F-4D85-A153-E20ECDC273CF}', '{1F61EE21-AC7D-411A-9F40-7101E87742FF}', 'Bug 3', 8, '20110709 15:07:49.697', '<p>I can''t change my status</p>', NULL, '{3E44B415-597D-4F9F-A350-A31D8260271E}', '{60C3360F-76AF-4036-833C-BCBC64E5B1C2}', '{3518090B-549F-4033-A467-183495D816F3}', 'Improvement', '1.0', 'Low', 'In Process', 0)
GO

INSERT INTO [dbo].[Defect] ([DefectId], [ProjectId], [DefectTitle], [DefectNumber], [CreatedDate], [Description], [Diagnosis], [AssignedMember], [Creator], [Originator], [Type], [Version], [Priority], [Status], [IsClosed])
VALUES 
  ('{09937888-0D61-48D1-8E41-F2298A74DDA4}', '{797EC3E0-1895-4497-8337-39E274EA35AC}', 'Bug 2', 2, '20110709 14:51:16.883', '<p>I can add defect, It thow many exception</p>', 'I don''t know', '{32235B19-DB94-486C-8BC8-6A194985527F}', '{60C3360F-76AF-4036-833C-BCBC64E5B1C2}', '{3518090B-549F-4033-A467-183495D816F3}', 'Bug', '1.0', 'High', 'Not Started', 0)
GO

--
-- 11 record(s) inserted to [dbo].[Defect]
--



--
-- Data for table Attachment  (LIMIT 0,500)
--

--
-- 0 record(s) inserted to [dbo].[Attachment]
--



--
-- Data for table Comment  (LIMIT 0,500)
--

INSERT INTO [dbo].[Comment] ([CommentId], [DefectId], [Comment], [Creator], [CreatedDate])
VALUES 
  ('{0DA39272-85BC-4356-94FE-37D40DF0FD22}', '{9548A0D1-4F38-44CD-9743-A6107A18E6FD}', '<p>@@</p>', '{60C3360F-76AF-4036-833C-BCBC64E5B1C2}', '20110709 14:52:18.900')
GO

--
-- 1 record(s) inserted to [dbo].[Comment]
--



--
-- Data for table DefectLog  (LIMIT 0,500)
--

INSERT INTO [dbo].[DefectLog] ([LogId], [Content], [User], [CreatedTime], [DefectId])
VALUES 
  ('{422897ED-6580-4894-A8F1-13DEF5AAF6F5}', 'This defect is created', '{60C3360F-76AF-4036-833C-BCBC64E5B1C2}', '20110709 14:50:33.870', '{9548A0D1-4F38-44CD-9743-A6107A18E6FD}')
GO

INSERT INTO [dbo].[DefectLog] ([LogId], [Content], [User], [CreatedTime], [DefectId])
VALUES 
  ('{2FA924D3-F813-4E8B-9B26-1FE347D78DD1}', 'This defect is created', '{60C3360F-76AF-4036-833C-BCBC64E5B1C2}', '20110709 14:51:38.263', '{A82D74E6-451C-4DFA-A890-60F23EC91E0F}')
GO

INSERT INTO [dbo].[DefectLog] ([LogId], [Content], [User], [CreatedTime], [DefectId])
VALUES 
  ('{556ADEA9-232F-407D-B1F2-23615C08CE34}', 'This defect is created', '{60C3360F-76AF-4036-833C-BCBC64E5B1C2}', '20110709 15:07:11.667', '{98ACCF5B-C3B1-447B-93FC-7F12E137F741}')
GO

INSERT INTO [dbo].[DefectLog] ([LogId], [Content], [User], [CreatedTime], [DefectId])
VALUES 
  ('{D4E101D5-003D-4B49-B6E9-379C2E5548D4}', 'This defect is created', '{60C3360F-76AF-4036-833C-BCBC64E5B1C2}', '20110709 15:07:49.793', '{8DAC0B34-BD6F-4D85-A153-E20ECDC273CF}')
GO

INSERT INTO [dbo].[DefectLog] ([LogId], [Content], [User], [CreatedTime], [DefectId])
VALUES 
  ('{0166950F-FDF2-450A-80AE-3D683B0F2E8B}', 'This defect is created', '{60C3360F-76AF-4036-833C-BCBC64E5B1C2}', '20110709 14:51:16.920', '{09937888-0D61-48D1-8E41-F2298A74DDA4}')
GO

INSERT INTO [dbo].[DefectLog] ([LogId], [Content], [User], [CreatedTime], [DefectId])
VALUES 
  ('{E6C1EF7A-AD23-4228-9D6B-6DDE207D5945}', 'This defect is created', '{60C3360F-76AF-4036-833C-BCBC64E5B1C2}', '20110709 15:14:44.700', '{E5EE9468-4700-44A6-8C15-7C11DB245BE7}')
GO

INSERT INTO [dbo].[DefectLog] ([LogId], [Content], [User], [CreatedTime], [DefectId])
VALUES 
  ('{A02DE0A5-737F-4A20-A8A7-89E764B93F2D}', 'Assigner is changed from nobody to dungdoan', '{60C3360F-76AF-4036-833C-BCBC64E5B1C2}', '20110709 15:00:13.603', '{107FD9CE-CDD1-4F48-A35A-7CFC97F72FDF}')
GO

INSERT INTO [dbo].[DefectLog] ([LogId], [Content], [User], [CreatedTime], [DefectId])
VALUES 
  ('{C3F243AF-BC63-4A78-8FE0-9912140E4B23}', 'This defect is created', '{60C3360F-76AF-4036-833C-BCBC64E5B1C2}', '20110709 15:12:19.410', '{EC26AE17-AB4D-4E6E-8896-4D91C42DC964}')
GO

INSERT INTO [dbo].[DefectLog] ([LogId], [Content], [User], [CreatedTime], [DefectId])
VALUES 
  ('{BF6F408A-D2AE-4514-B266-A65E7B02C58C}', 'This defect is created', '{60C3360F-76AF-4036-833C-BCBC64E5B1C2}', '20110709 15:14:17.960', '{8CFBFDFC-62BF-4F2E-ACB0-3E7C72CC5A22}')
GO

INSERT INTO [dbo].[DefectLog] ([LogId], [Content], [User], [CreatedTime], [DefectId])
VALUES 
  ('{CD069CB3-3BEC-4378-8766-C30D292EDCE9}', 'This defect is created', '{60C3360F-76AF-4036-833C-BCBC64E5B1C2}', '20110709 15:01:32.953', '{7B335EDB-EE45-4253-80B0-684C32CE43EE}')
GO

INSERT INTO [dbo].[DefectLog] ([LogId], [Content], [User], [CreatedTime], [DefectId])
VALUES 
  ('{C50B53B6-9103-4365-9DA0-CCDA664D6C30}', 'This defect is created', '{60C3360F-76AF-4036-833C-BCBC64E5B1C2}', '20110709 14:59:27.487', '{107FD9CE-CDD1-4F48-A35A-7CFC97F72FDF}')
GO

INSERT INTO [dbo].[DefectLog] ([LogId], [Content], [User], [CreatedTime], [DefectId])
VALUES 
  ('{92D5D684-D69B-4A53-89D9-E4354D0301CA}', 'This defect is created', '{60C3360F-76AF-4036-833C-BCBC64E5B1C2}', '20110709 15:07:29.823', '{72E1A74F-B8E2-48FF-955B-A59D62DE61E5}')
GO

--
-- 12 record(s) inserted to [dbo].[DefectLog]
--



--
-- Data for table DefectPriority  (LIMIT 0,500)
--

INSERT INTO [dbo].[DefectPriority] ([Priority], [ProjectId])
VALUES 
  ('High', '{797EC3E0-1895-4497-8337-39E274EA35AC}')
GO

INSERT INTO [dbo].[DefectPriority] ([Priority], [ProjectId])
VALUES 
  ('High', '{1F61EE21-AC7D-411A-9F40-7101E87742FF}')
GO

INSERT INTO [dbo].[DefectPriority] ([Priority], [ProjectId])
VALUES 
  ('Low', '{797EC3E0-1895-4497-8337-39E274EA35AC}')
GO

INSERT INTO [dbo].[DefectPriority] ([Priority], [ProjectId])
VALUES 
  ('Low', '{1F61EE21-AC7D-411A-9F40-7101E87742FF}')
GO

INSERT INTO [dbo].[DefectPriority] ([Priority], [ProjectId])
VALUES 
  ('Medium', '{797EC3E0-1895-4497-8337-39E274EA35AC}')
GO

INSERT INTO [dbo].[DefectPriority] ([Priority], [ProjectId])
VALUES 
  ('Medium', '{1F61EE21-AC7D-411A-9F40-7101E87742FF}')
GO

--
-- 6 record(s) inserted to [dbo].[DefectPriority]
--



--
-- Data for table DefectResolution  (LIMIT 0,500)
--

--
-- 0 record(s) inserted to [dbo].[DefectResolution]
--



--
-- Data for table DefectStatus  (LIMIT 0,500)
--

INSERT INTO [dbo].[DefectStatus] ([Status], [ProjectId])
VALUES 
  ('Complete', '{1F61EE21-AC7D-411A-9F40-7101E87742FF}')
GO

INSERT INTO [dbo].[DefectStatus] ([Status], [ProjectId])
VALUES 
  ('Completed', '{797EC3E0-1895-4497-8337-39E274EA35AC}')
GO

INSERT INTO [dbo].[DefectStatus] ([Status], [ProjectId])
VALUES 
  ('In Process', '{797EC3E0-1895-4497-8337-39E274EA35AC}')
GO

INSERT INTO [dbo].[DefectStatus] ([Status], [ProjectId])
VALUES 
  ('In Process', '{1F61EE21-AC7D-411A-9F40-7101E87742FF}')
GO

INSERT INTO [dbo].[DefectStatus] ([Status], [ProjectId])
VALUES 
  ('Not Started', '{797EC3E0-1895-4497-8337-39E274EA35AC}')
GO

INSERT INTO [dbo].[DefectStatus] ([Status], [ProjectId])
VALUES 
  ('Not Started', '{1F61EE21-AC7D-411A-9F40-7101E87742FF}')
GO

--
-- 6 record(s) inserted to [dbo].[DefectStatus]
--



--
-- Data for table DefectType  (LIMIT 0,500)
--

INSERT INTO [dbo].[DefectType] ([TypeName], [ProjectId])
VALUES 
  ('Bug', '{797EC3E0-1895-4497-8337-39E274EA35AC}')
GO

INSERT INTO [dbo].[DefectType] ([TypeName], [ProjectId])
VALUES 
  ('Bug', '{1F61EE21-AC7D-411A-9F40-7101E87742FF}')
GO

INSERT INTO [dbo].[DefectType] ([TypeName], [ProjectId])
VALUES 
  ('Document', '{797EC3E0-1895-4497-8337-39E274EA35AC}')
GO

INSERT INTO [dbo].[DefectType] ([TypeName], [ProjectId])
VALUES 
  ('Document', '{1F61EE21-AC7D-411A-9F40-7101E87742FF}')
GO

INSERT INTO [dbo].[DefectType] ([TypeName], [ProjectId])
VALUES 
  ('Improvement', '{797EC3E0-1895-4497-8337-39E274EA35AC}')
GO

INSERT INTO [dbo].[DefectType] ([TypeName], [ProjectId])
VALUES 
  ('Improvement', '{1F61EE21-AC7D-411A-9F40-7101E87742FF}')
GO

--
-- 6 record(s) inserted to [dbo].[DefectType]
--



--
-- Data for table EmailNotificationSettings  (LIMIT 0,500)
--

INSERT INTO [dbo].[EmailNotificationSettings] ([AccountId], [CaseId], [Temp])
VALUES 
  ('{60C3360F-76AF-4036-833C-BCBC64E5B1C2}', 'DefectAssignedToMe', NULL)
GO

INSERT INTO [dbo].[EmailNotificationSettings] ([AccountId], [CaseId], [Temp])
VALUES 
  ('{60C3360F-76AF-4036-833C-BCBC64E5B1C2}', 'DefectAssignedToMeClosed', NULL)
GO

INSERT INTO [dbo].[EmailNotificationSettings] ([AccountId], [CaseId], [Temp])
VALUES 
  ('{60C3360F-76AF-4036-833C-BCBC64E5B1C2}', 'DefectAssignedToMeNewComment', NULL)
GO

INSERT INTO [dbo].[EmailNotificationSettings] ([AccountId], [CaseId], [Temp])
VALUES 
  ('{60C3360F-76AF-4036-833C-BCBC64E5B1C2}', 'DefectAssignedToMePriorityChange', NULL)
GO

INSERT INTO [dbo].[EmailNotificationSettings] ([AccountId], [CaseId], [Temp])
VALUES 
  ('{60C3360F-76AF-4036-833C-BCBC64E5B1C2}', 'DefectAssignedToMeReOpened', NULL)
GO

INSERT INTO [dbo].[EmailNotificationSettings] ([AccountId], [CaseId], [Temp])
VALUES 
  ('{60C3360F-76AF-4036-833C-BCBC64E5B1C2}', 'DefectAssignedToMeStatusChange', NULL)
GO

INSERT INTO [dbo].[EmailNotificationSettings] ([AccountId], [CaseId], [Temp])
VALUES 
  ('{60C3360F-76AF-4036-833C-BCBC64E5B1C2}', 'DefectCreatedByMe', NULL)
GO

INSERT INTO [dbo].[EmailNotificationSettings] ([AccountId], [CaseId], [Temp])
VALUES 
  ('{60C3360F-76AF-4036-833C-BCBC64E5B1C2}', 'DefectCreatedByMeClosed', NULL)
GO

INSERT INTO [dbo].[EmailNotificationSettings] ([AccountId], [CaseId], [Temp])
VALUES 
  ('{60C3360F-76AF-4036-833C-BCBC64E5B1C2}', 'DefectCreatedByMeNewComment', NULL)
GO

INSERT INTO [dbo].[EmailNotificationSettings] ([AccountId], [CaseId], [Temp])
VALUES 
  ('{60C3360F-76AF-4036-833C-BCBC64E5B1C2}', 'DefectCreatedByMePriorityChange', NULL)
GO

INSERT INTO [dbo].[EmailNotificationSettings] ([AccountId], [CaseId], [Temp])
VALUES 
  ('{60C3360F-76AF-4036-833C-BCBC64E5B1C2}', 'DefectCreatedByMeReOpened', NULL)
GO

INSERT INTO [dbo].[EmailNotificationSettings] ([AccountId], [CaseId], [Temp])
VALUES 
  ('{60C3360F-76AF-4036-833C-BCBC64E5B1C2}', 'DefectCreatedByMeStatusChange', NULL)
GO

INSERT INTO [dbo].[EmailNotificationSettings] ([AccountId], [CaseId], [Temp])
VALUES 
  ('{60C3360F-76AF-4036-833C-BCBC64E5B1C2}', 'DefectReassignedToSomeOneElse', NULL)
GO

--
-- 13 record(s) inserted to [dbo].[EmailNotificationSettings]
--



--
-- Data for table Profile  (LIMIT 0,500)
--

INSERT INTO [dbo].[Profile] ([ProfileId], [AccountId], [FirstName], [LastName], [Address], [Email])
VALUES 
  ('{E71DCFA4-A6C6-4360-8DD4-0B2D950CF403}', '{24BCBED1-C724-45CE-9F75-6FCACE0FA18E}', 'Tony', 'Tran', NULL, 'tony8590@gmail.com')
GO

INSERT INTO [dbo].[Profile] ([ProfileId], [AccountId], [FirstName], [LastName], [Address], [Email])
VALUES 
  ('{67D6492B-A1A3-42E7-8A9A-16E570D1F219}', '{B700F39E-BAEB-4FB6-AA13-366E158EF43A}', 'Nam', 'Tran', 'Lac Trung', 'robo8590@gmail.com')
GO

INSERT INTO [dbo].[Profile] ([ProfileId], [AccountId], [FirstName], [LastName], [Address], [Email])
VALUES 
  ('{0B05BFCE-0A6D-4836-8CE3-3F84E523E472}', '{925872DB-E99B-4639-8B15-F32A2545AB5F}', 'Nguyen', 'Nguyen', NULL, 'nguyen@gmail.com')
GO

INSERT INTO [dbo].[Profile] ([ProfileId], [AccountId], [FirstName], [LastName], [Address], [Email])
VALUES 
  ('{CE29C698-0431-4C69-A4EA-6C942A773B94}', '{68CF8395-7408-4B82-80DD-9D26592C426B}', 'Join', 'Nguyen', NULL, 'joinnguyen@gmail.com')
GO

INSERT INTO [dbo].[Profile] ([ProfileId], [AccountId], [FirstName], [LastName], [Address], [Email])
VALUES 
  ('{2398D853-DCD8-43CF-BDAE-7CB317885E3C}', '{91FAE1EC-4BA6-4EF2-B97F-4E4F47B7FC28}', 'Toby', 'Nguyen', NULL, 'tobynguyen@gmail.com')
GO

INSERT INTO [dbo].[Profile] ([ProfileId], [AccountId], [FirstName], [LastName], [Address], [Email])
VALUES 
  ('{04202DC5-477F-4866-A72C-8817F8F046EE}', '{5FF59522-7A76-48E5-AD74-ACF4B6ECCF34}', 'Linda', 'Tran', NULL, 'lindatran@gmail.com')
GO

INSERT INTO [dbo].[Profile] ([ProfileId], [AccountId], [FirstName], [LastName], [Address], [Email])
VALUES 
  ('{6D8E546E-8A4D-4629-9B9A-99C27689D100}', '{32235B19-DB94-486C-8BC8-6A194985527F}', 'Chung', 'Nguyen', NULL, 'chung1991@gmail.com')
GO

INSERT INTO [dbo].[Profile] ([ProfileId], [AccountId], [FirstName], [LastName], [Address], [Email])
VALUES 
  ('{E948A132-F45C-4D67-89D8-A0B304F954E0}', '{60C3360F-76AF-4036-833C-BCBC64E5B1C2}', 'Nam', 'Tran', 'Lac Trung', 'nam8590@gmail.com')
GO

INSERT INTO [dbo].[Profile] ([ProfileId], [AccountId], [FirstName], [LastName], [Address], [Email])
VALUES 
  ('{667B8FB6-2BA7-4A54-BF18-AA17377A128A}', '{3E44B415-597D-4F9F-A350-A31D8260271E}', 'Lily', 'Tran', NULL, 'lilytran@gmail.com')
GO

INSERT INTO [dbo].[Profile] ([ProfileId], [AccountId], [FirstName], [LastName], [Address], [Email])
VALUES 
  ('{D7E167CC-F63A-4A2B-9C94-ADECC7451461}', '{A3338CFA-E392-43E8-99F2-C64E283EF37D}', 'Dung', 'Doan', NULL, 'dungdoan@gmail.com')
GO

INSERT INTO [dbo].[Profile] ([ProfileId], [AccountId], [FirstName], [LastName], [Address], [Email])
VALUES 
  ('{F5943334-93EB-4FF5-B2D7-B36F1349F56A}', '{91D0B3EC-FAB6-4B3E-A2F8-81AB0178B3E1}', 'Canh', 'Nguyen', NULL, 'ndc91091@gmail.com')
GO

--
-- 11 record(s) inserted to [dbo].[Profile]
--



--
-- Data for table ProjectMembers  (LIMIT 0,500)
--

INSERT INTO [dbo].[ProjectMembers] ([AccountId], [ProjectId], [IsAssigned])
VALUES 
  ('{91FAE1EC-4BA6-4EF2-B97F-4E4F47B7FC28}', '{797EC3E0-1895-4497-8337-39E274EA35AC}', 0)
GO

INSERT INTO [dbo].[ProjectMembers] ([AccountId], [ProjectId], [IsAssigned])
VALUES 
  ('{32235B19-DB94-486C-8BC8-6A194985527F}', '{797EC3E0-1895-4497-8337-39E274EA35AC}', 1)
GO

INSERT INTO [dbo].[ProjectMembers] ([AccountId], [ProjectId], [IsAssigned])
VALUES 
  ('{32235B19-DB94-486C-8BC8-6A194985527F}', '{1F61EE21-AC7D-411A-9F40-7101E87742FF}', 1)
GO

INSERT INTO [dbo].[ProjectMembers] ([AccountId], [ProjectId], [IsAssigned])
VALUES 
  ('{24BCBED1-C724-45CE-9F75-6FCACE0FA18E}', '{797EC3E0-1895-4497-8337-39E274EA35AC}', 0)
GO

INSERT INTO [dbo].[ProjectMembers] ([AccountId], [ProjectId], [IsAssigned])
VALUES 
  ('{24BCBED1-C724-45CE-9F75-6FCACE0FA18E}', '{1F61EE21-AC7D-411A-9F40-7101E87742FF}', 0)
GO

INSERT INTO [dbo].[ProjectMembers] ([AccountId], [ProjectId], [IsAssigned])
VALUES 
  ('{91D0B3EC-FAB6-4B3E-A2F8-81AB0178B3E1}', '{1F61EE21-AC7D-411A-9F40-7101E87742FF}', 0)
GO

INSERT INTO [dbo].[ProjectMembers] ([AccountId], [ProjectId], [IsAssigned])
VALUES 
  ('{68CF8395-7408-4B82-80DD-9D26592C426B}', '{1F61EE21-AC7D-411A-9F40-7101E87742FF}', 1)
GO

INSERT INTO [dbo].[ProjectMembers] ([AccountId], [ProjectId], [IsAssigned])
VALUES 
  ('{3E44B415-597D-4F9F-A350-A31D8260271E}', '{1F61EE21-AC7D-411A-9F40-7101E87742FF}', 1)
GO

INSERT INTO [dbo].[ProjectMembers] ([AccountId], [ProjectId], [IsAssigned])
VALUES 
  ('{A3338CFA-E392-43E8-99F2-C64E283EF37D}', '{797EC3E0-1895-4497-8337-39E274EA35AC}', 1)
GO

INSERT INTO [dbo].[ProjectMembers] ([AccountId], [ProjectId], [IsAssigned])
VALUES 
  ('{A3338CFA-E392-43E8-99F2-C64E283EF37D}', '{1F61EE21-AC7D-411A-9F40-7101E87742FF}', 1)
GO

--
-- 10 record(s) inserted to [dbo].[ProjectMembers]
--



--
-- Data for table ProjectVersion  (LIMIT 0,500)
--

INSERT INTO [dbo].[ProjectVersion] ([VersionName], [ProjectId])
VALUES 
  ('1.0', '{797EC3E0-1895-4497-8337-39E274EA35AC}')
GO

INSERT INTO [dbo].[ProjectVersion] ([VersionName], [ProjectId])
VALUES 
  ('1.0', '{1F61EE21-AC7D-411A-9F40-7101E87742FF}')
GO

INSERT INTO [dbo].[ProjectVersion] ([VersionName], [ProjectId])
VALUES 
  ('1.1', '{797EC3E0-1895-4497-8337-39E274EA35AC}')
GO

INSERT INTO [dbo].[ProjectVersion] ([VersionName], [ProjectId])
VALUES 
  ('1.1', '{1F61EE21-AC7D-411A-9F40-7101E87742FF}')
GO

INSERT INTO [dbo].[ProjectVersion] ([VersionName], [ProjectId])
VALUES 
  ('1.2', '{797EC3E0-1895-4497-8337-39E274EA35AC}')
GO

INSERT INTO [dbo].[ProjectVersion] ([VersionName], [ProjectId])
VALUES 
  ('1.2', '{1F61EE21-AC7D-411A-9F40-7101E87742FF}')
GO